<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body><table id="top_location_line" width="100%"><table id="top_location_line" width="100%"><tr width="100%"><td><a href="http://www.urchin.com"><img border="0" src="../images/google_sm.gif" width="135" height="41"></a></td><td width="100%"><span id="top_line" style="width: 100%; float: left; clear: both; border-bottom: 1px solid #CCC;"><span id="top_title" style="float: left; margin-top: 10px;"><b>Help Center</b></span></td></tr></table>
<div id="page" lang="en" dir="ltr">
<div dir="ltr" id="content" lang="en">
<p class="line867"><hr class="hr1" /><p class="line874"> This article authored by <a href="%2522FriedrichsoftwareResources%2522.html">"FriedrichsoftwareResources"</a>, an Urchin Software Authorized Consultant  <hr class="hr1" /><p class="line874"> <strong>How do I recover from 'Unable to open database for writing since it has been archived' error? </strong> <p class="line874">When attempting to run a profile in Urchin 6, you receive this error: <p class="line867"><pre>WARNING: (7063-54-63) Unable to open database for writing
since it has been archived</pre><p class="line874">This error occurs because the log tracking databases are stored on a per month basis with Urchin. During processing, Urchin reads the first couple of lines from the log file, determines which month this log belongs to and attempts to open the databases for that month. Since the databases for that month have been archived, an error is returned because Urchin will not allow reading/writing to databases that have been archived.There are two workarounds: <ol type="1"><li>Turn off the archive feature and uncompress the *-archive.zip files for the affected profiles and remove the *-archive.zip files. </li><li>Change the log wildcarding to include a date matching string (perhaps YY* or YYYY* can be used to identify files only for this year). </li></ol></div><div id="pagebottom"></div>
</div>


<div id="footer" style="clear: both; margin: 0; padding: 0; border-bottom:1px solid #CCC;"></div><div id="copyright" style="font-size: 70%; text-align: center;">&copy;2010 Google</div>
</body></html>